SyCampusGrp 
Logical Entity Name  SyCampusGrp 
Default Table Name  SyCampusGrp 
Physical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

SyCampusGrp Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SyCampusGrpID(PK)    int  NO 
 
Code    char(16)  NO 
 
Descrip    varchar(35)  NO 
 
Userid    int  NO 
 
SystemCode    bit  NO 
 
SaStmtComments    varchar(1000)  YES 
 
SaStmtLastCloseDate    datetime  YES 
 
ModFlag    char(1)  NO 
 
Type    char(1)  NO 
 
Active    bit  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
ts    timestamp  NO 
 
FinancialCampusGroup    bit  NO 
 

SyCampusGrp Primary and Unique Keys 
Key Name  Key Type  Keys 
SyCampusGrp_Type_SyCampusGRPID_U_N_IDX  Index  Type, SyCampusGrpID 
SyCampusGrp_SyCampusGrpID_U_C_IDX  PrimaryKey  SyCampusGrpID 

SyCampusGrp Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
AdStartDate  Non-Identifying  One To Zero or More  FK__AdStartDa__SyCam__241614B4        NO  YES 
AdStartDateCalendar  Non-Identifying  One To Zero or More  FK__AdStartDa__SyCam__250A38ED        NO  YES 
AdAttribute  Non-Identifying  One To Zero or More  FK_AdAttribute_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
AdCatalogYear  Non-Identifying  One To Zero or More  FK_AdCatalogYear_SyCampusGrpId_SyCampusGrp_SyCampusGrpId        NO  YES 
AdClassSchedCancelReason  Non-Identifying  One To Zero or More  FK_AdClassSchedCancelReason_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
AdConcentration  Non-Identifying  One To Zero or More  FK_AdConcentration_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
AdCourseFulfillmentOrder  Non-Identifying  One To Zero or More  FK_AdCourseFulfillmentOrder_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
AdCoursePrefix  Non-Identifying  One To Zero or More  FK_AdCoursePrefix_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
AdCourseStatusChangeReason  Non-Identifying  One To Zero or More  FK_AdCourseStatusChangeReason_SycampusGrpID_SycampusGrp_SycampusGrpID        NO  YES 
AdFinalGradeReason  Non-Identifying  One To Zero or More  FK_AdFinalGradeReason_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
AdGPA  Non-Identifying  One To Zero or More  FK_AdGPASyCampusGrpID_SyCampusGrpSyCampusGrpID        NO  YES 
AdLesson  Non-Identifying  One To Zero or More  FK_AdLesson_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
AdLessonPlan  Non-Identifying  One To Zero or More  FK_AdLessonPlan_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
AdLocation  Non-Identifying  One To Zero or More  FK_AdLocation_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
AdProgramTermsInAY  Non-Identifying  One To Zero or More  FK_AdProgramTermsInAYSyCampusGrpID_SyCampusGrpSyCampusGrpID        NO  YES 
AdRegistrationGroup  Non-Identifying  One To Zero or More  FK_AdRegistrationGroup_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
AdTermProgramAssociation  Non-Identifying  One To Zero or More  FK_AdTermProgramAssociationSyCampusGrpID_SyCampusGrpSyCampusGrpID        NO  YES 
AmApplication  Non-Identifying  One To Zero or More  FK_AmApplication_SyCampusGrpId_SyCampusGrp_SyCampusGrpId        NO  YES 
AmExamLocation  Non-Identifying  One To Zero or More  FK_AmExamLocation_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
CmDocMgmtSftDetail  Non-Identifying  One To Zero or More  FK_CmDocMgmtSftDetail_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
faExcusedAbsencePolicy  Non-Identifying  One To Zero or More  FK_faExcusedAbsencePolicy_SyCampusGrpid_SyCampusGrp_SyCampusGrpID        NO  YES 
FaTermAssociationTrack  Non-Identifying  One To Zero or More  FK_FaTermAssociationTrack_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
FaTermAssociationTrackProgramVersion  Non-Identifying  One To Zero or More  FK_FaTermAssociationTrackProgramVersion_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
FaTermTrack  Non-Identifying  One To Zero or More  FK_FaTermTrack_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
HsBuilding  Non-Identifying  One To Zero or More  FK_HsBuilding_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
HsBuildingCategories  Non-Identifying  One To Zero or More  FK_hsBuildingCategories_syCampusGrpID_syCampusGrp_syCampusGrpID        NO  YES 
HsHousingDates  Non-Identifying  One To Zero or More  FK_HsHousingDates_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
HsRoomCategories  Non-Identifying  One To Zero or More  FK_hsRoomCategories_syCampusGrpID_syCampusGrp_syCampusGrpID        NO  YES 
HsSuiteCategories  Non-Identifying  One To Zero or More  FK_hsSuiteCategories_syCampusGrpID_syCampusGrp_syCampusGrpID        NO  YES 
PlAttribute  Non-Identifying  One To Zero or More  FK_PlAttribute.SyCampusGrpID_SyCampusGrp.SyCampusGrpID        NO  YES 
PlCertifications  Non-Identifying  One To Zero or More  FK_PlCertifications.SyCampusGrpID_SyCampusGrp.SyCampusGrpID        NO  YES 
PlEmployerCareerField  Non-Identifying  One To Zero or More  FK_PLEmployerCareerField_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
PlEmployerContactJobSkill  Non-Identifying  One To Zero or More  FK_PlEmployerContactJobSkill_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
PlEmployerContactSoftSkill  Non-Identifying  One To Zero or More  FK_PlEmployerContactSoftSkill_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
PlEmployerSoftSkill  Non-Identifying  One To Zero or More  FK_PlEmployerSoftSkill_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
PlJobBenefits  Non-Identifying  One To Zero or More  FK_PlJobBenefits.SyCampusGrpID_SyCampusGrp.SyCampusGrpID        NO  YES 
SaAcctStatus  Non-Identifying  One To Zero or More  FK_SaAcctStatus_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
SaGLBatch  Non-Identifying  One To Zero or More  FK_SaGlBatch_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
SaJournalEntryGrp  Non-Identifying  One To Zero or More  FK_SaJournalEntryGrp_SyCampusGrpId_SyCampusGrp_SyCampusGrpId        NO  YES 
SaSubsidiary  Non-Identifying  One To Zero or More  FK_SaSubsidiary_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
SaTuitionDiscountPolicy  Non-Identifying  One To Zero or More  FK_SaTuitionDiscountPolicy_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
SsAthleticStatus  Non-Identifying  One To Zero or More  FK_SsAthleticStatusSyCampusGrpID_SyCampusGrpSyCampusGrpID        NO  YES 
SsDisabilityStatus  Non-Identifying  One To Zero or More  FK_SsDisabilityStatusSyCampusGrpID_SyCampusGrpSyCampusGrpID        NO  YES 
SsRecruitmentType  Non-Identifying  One To Zero or More  FK_SsRecruitmentTypeSyCampusGrpID_SyCampusGrpSyCampusGrpID        NO  YES 
SsRoomType  Non-Identifying  One To Zero or More  FK_SsRoomType_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
SsService  Non-Identifying  One To Zero or More  FK_SsService_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
SsServiceCategory  Non-Identifying  One To Zero or More  FK_SsServiceCategory_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
SsSports  Non-Identifying  One To Zero or More  FK_SsSportsSyCampusGrpID_SyCampusGrpSyCampusGrpID        NO  YES 
SyEmpGroups  Non-Identifying  One To Zero or More  FK_SyEmpGroups_SyCampusGrpId_SyCampusGrp_SyCampusGrpId        NO  YES 
SyEmpGrp  Non-Identifying  One To Zero or More  FK_SyEmpGrp_SyCampusGrpId_SyCampusGrp_SyCampusGrpId        NO  YES 
syIMSConfiguration  Non-Identifying  One To Zero or More  FK_SyIMSConfiguration_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
SyIndicator  Non-Identifying  One To Zero or More  FK_SyIndicator_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
SyOrganization  Non-Identifying  One To Zero or More  FK_SyOrganization_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
SyResidencyStatus  Non-Identifying  One To Zero or More  FK_SyResidencyStatus_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  NO 
SyResidencyType  Non-Identifying  One To Zero or More  FK_SyResidencyType_SyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  NO 
SySEVISCampus  Non-Identifying  One To Zero or More  FK_SySEVISCampus_SEVISSyCampusGrpID_SyCampusGrp_SyCampusGrpID        NO  YES 
SyStaffGroupTemplate  Non-Identifying  One To Zero or More  FK_SyStaffGroupTemplate_SyCampusGrpId_SyCampusGrp_SyCampusGrpId        NO  YES 

SyCampusGrp Check Constraints 
Check Constraint Name  CheckConstraint 

SyCampusGrp Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  PRIMARY 
Text Image File Group   

SyCampusGrp Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.CampusGroup 
NO       
Physical (Microsoft SQL Server)
dbo.SyCampusGrp 
NO       

SyCampusGrp Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  SEVIS 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Academic Records 
Physical (Microsoft SQL Server)  System 

SyCampusGrp Data Movement Rules 
Name  Type  Rule Text/Value